package com.simtop.hj.pojo;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.metadata.BaseRowModel;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;

import java.util.Date;

@Data
public class DownGrade extends BaseRowModel {

    @ExcelIgnore
    private Integer gradeId;

    @ColumnWidth(value =30)
    @ExcelProperty(index = 0, value = "实验时长(min)")
    private Integer gradeExperimentTime;

    @ColumnWidth(value =30)
    @ExcelProperty(index = 1, value = "实验时间")
    @JsonFormat(pattern="yyyy-MM-dd",timezone="GMT+8")
    private Date gradeExperimentDate;

    @ColumnWidth(value =30)
    @ExcelProperty(index = 2, value = "实验分数")
    private Integer score;

    @ExcelIgnore
    /*@ColumnWidth(value =30)
    @ExcelProperty(index = 4, value = "用户编号")*/
    private Integer userId;

    @ColumnWidth(value =30)
    @ExcelProperty(index = 3, value = "真实姓名")
    private String username;

    @ColumnWidth(value =30)
    @ExcelProperty(index = 4, value = "用户名")
    private String loginName;

    /**
     * 课程序号
     */
    @ColumnWidth(value =30)
    @ExcelProperty(index = 5, value = "课程序号")
    private String subjects;

    /**
     * 上课年份
     */
    @ColumnWidth(value =30)
    @ExcelProperty(index = 6, value = "上课年份")
    private Integer studyYear;

    /**
     * 班级
     */
    @ExcelIgnore
    private String classes;

    @ColumnWidth(value =50)
    @ExcelProperty(index = 7, value = "答题情况")
    private String comment;

    @ExcelIgnore
    /*@ColumnWidth(value =30)
    @ExcelProperty(index = 10, value = "评分星星分数")*/
    private Integer commentScore;

    @ExcelIgnore
    /*@ColumnWidth(value =30)
    @ExcelProperty(index = 11, value = "跨境电商认知")*/
    private String cognition;

    @ExcelIgnore
    /*@ColumnWidth(value =30)
    @ExcelProperty(index = 12, value = "数据应用技能")*/
    private String skill;

    @ExcelIgnore
    /*@ColumnWidth(value =30)
    @ExcelProperty(index = 13, value = "红酒领域知识")*/
    private String field;

    @ExcelIgnore
    /*@ColumnWidth(value =30)
    @ExcelProperty(index = 14, value = "数据建模与决策")*/
    private String modeling;

    @ExcelIgnore
    /*@ColumnWidth(value =30)
    @ExcelProperty(index = 15, value = "商务分析思维")*/
    private String thinking;

    @ExcelIgnore
    /*@ColumnWidth(value =30)
    @ExcelProperty(index = 16, value = "理论学习信息分数")*/
    private Integer theoreticalStudyScore;//理论学习信息分数

    @ExcelIgnore
    /*@ColumnWidth(value =30)
    @ExcelProperty(index = 17, value = "数据抓取信息分数")*/
    private Integer fetchingInfoScore;//数据抓取信息分数

    @ExcelIgnore
    /*@ColumnWidth(value =30)
    @ExcelProperty(index = 18, value = "数据清洗信息分数")*/
    private Integer cleaningInfoScore;//数据清洗信息分数

    @ExcelIgnore
    /*@ColumnWidth(value =30)
    @ExcelProperty(index = 19, value = "数据分析信息分数")*/
    private Integer analysisScore;//数据分析信息分数

    /**
     * 各分项得分
     */
    @ExcelIgnore
    private String scoreArray;

    @ColumnWidth(value =30)
    @ExcelProperty(index = 8, value = "认知价值定价法")
    private Integer cognitiveValuePrice;

    @ColumnWidth(value =30)
    @ExcelProperty(index = 9, value = "竞品分析定价法")
    private Integer competitiveAnalysisPricing;

    @ColumnWidth(value =30)
    @ExcelProperty(index = 10, value = "机器学习定价法")
    private Integer machineLearningPricing;

    @ColumnWidth(value =30)
    @ExcelProperty(index = 11, value = "成长品定价法")
    private Integer growthProductPricing;
}
